package me.zhengjie.modules.management.mapper;

import com.baomidou.dynamic.datasource.annotation.DS;
import me.zhengjie.modules.management.domain.RoomUser;
import me.zhengjie.modules.management.domain.RoomUserView;
import org.apache.ibatis.annotations.Mapper;

import java.util.Date;
import java.util.List;

/**
 * @Author: chenxin.jiang
 * @Date: 2020/12/22
 * @Description:
 */
@DS("other")
@Mapper
public interface MrUserViewMapper {
    /**
     * 获取startTime时间到现在Hr中间库中人员表变动过的数据
     * @param
     * @return RoomUserView>
     */
    List<RoomUserView> findRoomUserView(Date startTime);

    /**
     * 根据hr_user表里面的工号查询视图里是否存在此人
     */
    RoomUserView findRoomUserViewByJobNum(String jobNumber);
}
